Overview

Dataset info

Number of variables37
Number of observations83001
Missing cells204622 (6.7%)
Duplicate rows0 (0.0%)
Total size in memory23.4 MiB
Average record size in memory296.0 B

Variables types

Numeric27
Categorical7
Boolean0
Date0
URL0
Text (Unique)0
Rejected3
Unsupported0

Warnings

amenities has a high cardinality: 72957 distinct values Warning
bedrooms has 5083 (6.1%) zeros Zeros
beds has 2123 (2.6%) zeros Zeros
calculated_host_listings_count_entire_homes is highly correlated with calculated_host_listings_count (ρ = 0.9985904365) Rejected
calculated_host_listings_count_private_rooms has 40010 (48.2%) zeros Zeros
calculated_host_listings_count_shared_rooms has 81831 (98.6%) zeros Zeros
cleaning_fee has 27272 (32.9%) zeros Zeros
extra_people has 50746 (61.1%) zeros Zeros
host_listings_count is highly correlated with calculated_host_listings_count_entire_homes (ρ = 0.9820095924) Rejected
host_response_rate has 1097 (1.3%) zeros Zeros
host_response_rate has 24307 (29.3%) missing values Missing
host_total_listings_count is highly correlated with host_listings_count (ρ = 1) Rejected
number_of_reviews has 20792 (25.1%) zeros Zeros
number_of_reviews_ltm has 33561 (40.4%) zeros Zeros
price is highly skewed (γ1 = 25.10330353) Skewed
review_scores_accuracy has 22485 (27.1%) missing values Missing
review_scores_checkin has 22537 (27.2%) missing values Missing
review_scores_cleanliness has 22474 (27.1%) missing values Missing
review_scores_communication has 22482 (27.1%) missing values Missing
review_scores_location has 22536 (27.2%) missing values Missing
review_scores_rating has 22434 (27.0%) missing values Missing
review_scores_value has 22535 (27.2%) missing values Missing
reviews_per_month has 20791 (25.0%) missing values Missing
security_deposit has 47852 (57.7%) zeros Zeros
zipcode has a high cardinality: 33819 distinct values Warning
zipcode has 1947 (2.3%) missing values Missing

Variables

accommodates
Numeric

Distinct count17
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3.18722666
Minimum0
Maximum16
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q12
Median2
Q34
95-th percentile7
Maximum16
Range16
Interquartile range2

Descriptive statistics

Standard deviation2.012540496
Coef of variation0.6314394021
Kurtosis4.401819508
Mean3.18722666
MAD1.577924631
Skewness1.688858785
Sum264543
Variance4.050319249
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%) 
2 34941 42.1%
 
4 16509 19.9%
 
1 10488 12.6%
 
6 6669 8.0%
 
3 5656 6.8%
 
5 3877 4.7%
 
8 2016 2.4%
 
7 1360 1.6%
 
10 530 0.6%
 
9 407 0.5%
 
Other values (7) 548 0.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
1 10488 12.6%
 
2 34941 42.1%
 
3 5656 6.8%
 
4 16509 19.9%
 

Maximum 5 values

ValueCountFrequency (%) 
16 102 0.1%
 
15 23 < 0.1%
 
14 88 0.1%
 
13 49 0.1%
 
12 178 0.2%
 

amenities
Categorical

Distinct count72957
Unique (%)87.9%
Missing (%)0.0%
Missing (n)0
{}
 
378
{TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Heating,"Suitable for events",Washer,Dryer,"Smoke detector","First aid kit",Essentials,"Hair dryer"}
 
100
{Wifi,Kitchen,Elevator,Heating,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Hot water","Bed linens","Extra pillows and blankets",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed","Well-lit path to entrance"}
 
93
Other values (72954)
82430
ValueCountFrequency (%) 
{} 378 0.5%
 
{TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Heating,"Suitable for events",Washer,Dryer,"Smoke detector","First aid kit",Essentials,"Hair dryer"} 100 0.1%
 
{Wifi,Kitchen,Elevator,Heating,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Hot water","Bed linens","Extra pillows and blankets",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed","Well-lit path to entrance"} 93 0.1%
 
{Wifi,Kitchen,Heating,Washer,Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hot water","Bed linens"} 66 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,Iron} 63 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} 47 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} 42 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,Iron,"Hot water","Bed linens",Microwave,Refrigerator,Dishwasher,"Dishes and silverware",Oven,Stove} 33 < 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance"} 33 < 0.1%
 
{"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"} 33 < 0.1%
 
Other values (72947) 82113 98.9%
 
Max length1572
Mean length277.0123011
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

bathrooms
Numeric

Distinct count25
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.294755485
Minimum0
Maximum24
Zeros (%)0.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
Median1
Q31.5
95-th percentile2.5
Maximum24
Range24
Interquartile range0.5

Descriptive statistics

Standard deviation0.6188631928
Coef of variation0.4779768844
Kurtosis54.83128571
Mean1.294755485
MAD0.4371899041
Skewness4.201405197
Sum107466
Variance0.3829916514
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=25)
Histogram
Histogram with variable size bins (bins=[ 0. 0.25 0.75 1.25 1.75 ... 6.25 8.25 9.75 10.25 24. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 58808 70.9%
 
2 11922 14.4%
 
1.5 6768 8.2%
 
2.5 2319 2.8%
 
3 1359 1.6%
 
3.5 536 0.6%
 
0 443 0.5%
 
0.5 297 0.4%
 
4 264 0.3%
 
4.5 97 0.1%
 
Other values (15) 188 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 443 0.5%
 
0.5 297 0.4%
 
1 58808 70.9%
 
1.5 6768 8.2%
 
2 11922 14.4%
 

Maximum 5 values

ValueCountFrequency (%) 
24 1 < 0.1%
 
17 2 < 0.1%
 
11 1 < 0.1%
 
10.5 1 < 0.1%
 
10 24 < 0.1%
 

bed_type
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Real Bed
82288
Pull-out Sofa
 
413
Futon
 
183
Other values (2)
 
117
ValueCountFrequency (%) 
Real Bed 82288 99.1%
 
Pull-out Sofa 413 0.5%
 
Futon 183 0.2%
 
Couch 70 0.1%
 
Airbed 47 0.1%
 
Max length13
Mean length8.014602234
Min length5
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

bedrooms
Numeric

Distinct count17
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.413380562
Minimum0
Maximum24
Zeros (%)6.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median1
Q32
95-th percentile3
Maximum24
Range24
Interquartile range1

Descriptive statistics

Standard deviation0.9259544054
Coef of variation0.6551345267
Kurtosis15.41542839
Mean1.413380562
MAD0.6906776395
Skewness2.212373846
Sum117312
Variance0.8573915608
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=17)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 5.5 6.5 7.5 10.5 24. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 51960 62.6%
 
2 17050 20.5%
 
3 5733 6.9%
 
0 5083 6.1%
 
4 2242 2.7%
 
5 690 0.8%
 
6 173 0.2%
 
7 41 < 0.1%
 
8 12 < 0.1%
 
10 7 < 0.1%
 
Other values (7) 10 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5083 6.1%
 
1 51960 62.6%
 
2 17050 20.5%
 
3 5733 6.9%
 
4 2242 2.7%
 

Maximum 5 values

ValueCountFrequency (%) 
24 1 < 0.1%
 
22 1 < 0.1%
 
21 1 < 0.1%
 
16 1 < 0.1%
 
12 1 < 0.1%
 

beds
Numeric

Distinct count25
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.745870532
Minimum0
Maximum55
Zeros (%)2.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
Median1
Q32
95-th percentile4
Maximum55
Range55
Interquartile range1

Descriptive statistics

Standard deviation1.28404785
Coef of variation0.7354771311
Kurtosis52.21031206
Mean1.745870532
MAD0.9084654458
Skewness3.602751761
Sum144909
Variance1.648778881
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=25)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 12.5 13.5 14.5 21. 55. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 45578 54.9%
 
2 19996 24.1%
 
3 8347 10.1%
 
4 3867 4.7%
 
0 2123 2.6%
 
5 1558 1.9%
 
6 816 1.0%
 
7 311 0.4%
 
8 184 0.2%
 
9 73 0.1%
 
Other values (15) 148 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2123 2.6%
 
1 45578 54.9%
 
2 19996 24.1%
 
3 8347 10.1%
 
4 3867 4.7%
 

Maximum 5 values

ValueCountFrequency (%) 
55 1 < 0.1%
 
28 1 < 0.1%
 
24 1 < 0.1%
 
22 1 < 0.1%
 
20 4 < 0.1%
 

calculated_host_listings_count
Numeric

Distinct count83
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean25.48952422
Minimum1
Maximum1161
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q34
95-th percentile62
Maximum1161
Range1160
Interquartile range3

Descriptive statistics

Standard deviation136.6106959
Coef of variation5.359483947
Kurtosis62.49948003
Mean25.48952422
MAD40.07294315
Skewness7.903121324
Sum2115656
Variance18662.48223
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[1.000e+00 1.500e+00 2.500e+00 3.500e+00 4.500e+00 ... 1.705e+02 1.950e+02 2.380e+02 7.120e+02 1.161e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 43014 51.8%
 
2 11793 14.2%
 
3 4729 5.7%
 
4 2863 3.4%
 
5 1795 2.2%
 
6 1341 1.6%
 
1161 1138 1.4%
 
7 1049 1.3%
 
8 892 1.1%
 
10 669 0.8%
 
Other values (73) 13718 16.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 43014 51.8%
 
2 11793 14.2%
 
3 4729 5.7%
 
4 2863 3.4%
 
5 1795 2.2%
 

Maximum 5 values

ValueCountFrequency (%) 
1161 1138 1.4%
 
263 263 0.3%
 
213 209 0.3%
 
177 177 0.2%
 
164 164 0.2%
 

calculated_host_listings_count_entire_homes
Highly correlated

This variable is highly correlated with calculated_host_listings_count and should be ignored for analysis

Correlation0.9985904365

calculated_host_listings_count_private_rooms
Numeric

Distinct count41
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.97228949
Minimum0
Maximum95
Zeros (%)48.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q31
95-th percentile6
Maximum95
Range95
Interquartile range1

Descriptive statistics

Standard deviation7.192389105
Coef of variation3.646720798
Kurtosis101.6009114
Mean1.97228949
MAD2.496535116
Skewness9.14303938
Sum163702
Variance51.73046103
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=41)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 37.5 46.5 81. 92.5 95. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 40010 48.2%
 
1 25400 30.6%
 
2 6715 8.1%
 
3 3646 4.4%
 
4 1633 2.0%
 
5 761 0.9%
 
6 688 0.8%
 
7 399 0.5%
 
10 374 0.5%
 
8 251 0.3%
 
Other values (31) 3124 3.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 40010 48.2%
 
1 25400 30.6%
 
2 6715 8.1%
 
3 3646 4.4%
 
4 1633 2.0%
 

Maximum 5 values

ValueCountFrequency (%) 
95 198 0.2%
 
90 93 0.1%
 
72 72 0.1%
 
49 49 0.1%
 
44 48 0.1%
 

calculated_host_listings_count_shared_rooms
Numeric

Distinct count15
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.06050529512
Minimum0
Maximum23
Zeros (%)98.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum23
Range23
Interquartile range0

Descriptive statistics

Standard deviation0.849479943
Coef of variation14.039762
Kurtosis449.8743391
Mean0.06050529512
MAD0.1193047989
Skewness19.92249922
Sum5022
Variance0.7216161736
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=15)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 10.5 20.5 23. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 81831 98.6%
 
1 708 0.9%
 
2 54 0.1%
 
23 47 0.1%
 
18 46 0.1%
 
12 40 < 0.1%
 
3 39 < 0.1%
 
8 38 < 0.1%
 
4 37 < 0.1%
 
10 34 < 0.1%
 
Other values (5) 127 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 81831 98.6%
 
1 708 0.9%
 
2 54 0.1%
 
3 39 < 0.1%
 
4 37 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
23 47 0.1%
 
18 46 0.1%
 
12 40 < 0.1%
 
11 12 < 0.1%
 
10 34 < 0.1%
 

cleaning_fee
Numeric

Distinct count247
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean31.61234202
Minimum0
Maximum850
Zeros (%)32.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median20
Q349
95-th percentile100
Maximum850
Range850
Interquartile range49

Descriptive statistics

Standard deviation42.97040263
Coef of variation1.359291969
Kurtosis20.43396555
Mean31.61234202
MAD29.27411487
Skewness3.30873087
Sum2623856
Variance1846.455503
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 2. 4.5 5.5 7.5 ... 353. 372.5 382. 512.5 850. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 27272 32.9%
 
20 5116 6.2%
 
30 4997 6.0%
 
10 4419 5.3%
 
50 3862 4.7%
 
15 3633 4.4%
 
40 3594 4.3%
 
25 3150 3.8%
 
60 2534 3.1%
 
35 1877 2.3%
 
Other values (237) 22547 27.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 27272 32.9%
 
4 316 0.4%
 
5 1542 1.9%
 
6 211 0.3%
 
7 264 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
850 1 < 0.1%
 
660 1 < 0.1%
 
614 1 < 0.1%
 
610 1 < 0.1%
 
600 2 < 0.1%
 

df_index
Numeric

Distinct count83001
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean42140.9591
Minimum0
Maximum83849
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile4150
Q121513
Median42346
Q363098
95-th percentile79699
Maximum83849
Range83849
Interquartile range41585

Descriptive statistics

Standard deviation24232.47157
Coef of variation0.5750336986
Kurtosis-1.195572242
Mean42140.9591
MAD20957.60718
Skewness-0.01987690692
Sum3497741746
Variance587212678.5
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 19577.5 21605.5 83849. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2047 1 < 0.1%
 
70327 1 < 0.1%
 
2708 1 < 0.1%
 
661 1 < 0.1%
 
6806 1 < 0.1%
 
4759 1 < 0.1%
 
27288 1 < 0.1%
 
25241 1 < 0.1%
 
31386 1 < 0.1%
 
29339 1 < 0.1%
 
Other values (82991) 82991 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
1 1 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
83849 1 < 0.1%
 
83848 1 < 0.1%
 
83847 1 < 0.1%
 
83846 1 < 0.1%
 
83845 1 < 0.1%
 

experiences_offered
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
none
81211
business
 
606
family
 
508
Other values (2)
 
676
ValueCountFrequency (%) 
none 81211 97.8%
 
business 606 0.7%
 
family 508 0.6%
 
social 452 0.5%
 
romantic 224 0.3%
 
Max length8
Mean length4.063131769
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

extra_people
Numeric

Distinct count105
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean7.450669269
Minimum0
Maximum239
Zeros (%)61.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q310
95-th percentile30
Maximum239
Range239
Interquartile range10

Descriptive statistics

Standard deviation14.00717298
Coef of variation1.879988558
Kurtosis48.3762008
Mean7.450669269
MAD9.271163573
Skewness4.921974547
Sum618413
Variance196.2008948
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 1.5 3.5 4.5 5.5 ... 152.5 197.5 205. 221.5 239. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50746 61.1%
 
10 7738 9.3%
 
15 6362 7.7%
 
20 4768 5.7%
 
25 2267 2.7%
 
5 2079 2.5%
 
30 1666 2.0%
 
50 1045 1.3%
 
12 637 0.8%
 
35 627 0.8%
 
Other values (95) 5066 6.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 50746 61.1%
 
3 1 < 0.1%
 
4 309 0.4%
 
5 2079 2.5%
 
6 223 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
239 1 < 0.1%
 
236 1 < 0.1%
 
235 4 < 0.1%
 
233 1 < 0.1%
 
232 1 < 0.1%
 

guests_included
Numeric

Distinct count17
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.610715534
Minimum1
Maximum22
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile4
Maximum22
Range21
Interquartile range1

Descriptive statistics

Standard deviation1.348327074
Coef of variation0.8370982002
Kurtosis15.67421192
Mean1.610715534
MAD0.8837168039
Skewness3.31576737
Sum133691
Variance1.817985899
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=17)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 10.5 12.5 13.5 19. 22. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 60052 72.4%
 
2 12598 15.2%
 
4 5315 6.4%
 
3 1580 1.9%
 
6 1579 1.9%
 
5 886 1.1%
 
8 449 0.5%
 
7 249 0.3%
 
10 117 0.1%
 
9 78 0.1%
 
Other values (7) 98 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 60052 72.4%
 
2 12598 15.2%
 
3 1580 1.9%
 
4 5315 6.4%
 
5 886 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
22 1 < 0.1%
 
16 29 < 0.1%
 
15 12 < 0.1%
 
14 7 < 0.1%
 
13 1 < 0.1%
 

host_id
Numeric

Distinct count52739
Unique (%)63.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean78575511.92
Minimum2010
Maximum274979066
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2010
5-th percentile1849921
Q114510588
Median44556133
Q3133680018
95-th percentile241034482
Maximum274979066
Range274977056
Interquartile range119169430

Descriptive statistics

Standard deviation78499274.18
Coef of variation0.9990297519
Kurtosis-0.3535694039
Mean78575511.92
MAD66559211.81
Skewness0.9444207288
Sum6.521846065e+12
Variance6.162136047e+15
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[2.01000000e+03 5.49060000e+04 5.55455000e+04 6.72755000e+04 6.84845000e+04 ... 2.73971277e+08 2.73987192e+08 2.74141040e+08 2.74170878e+08 2.74979066e+08], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
33889201 1138 1.4%
 
156158778 263 0.3%
 
28820321 209 0.3%
 
137094377 177 0.2%
 
48165024 164 0.2%
 
1432477 160 0.2%
 
27572615 134 0.2%
 
224866971 114 0.1%
 
50291093 113 0.1%
 
83740964 102 0.1%
 
Other values (52729) 80427 96.9%
 

Minimum 5 values

ValueCountFrequency (%) 
2010 1 < 0.1%
 
2697 1 < 0.1%
 
4775 7 < 0.1%
 
5653 1 < 0.1%
 
6774 3 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
274979066 1 < 0.1%
 
274953295 1 < 0.1%
 
274950405 1 < 0.1%
 
274946144 1 < 0.1%
 
274944036 1 < 0.1%
 

host_listings_count
Highly correlated

This variable is highly correlated with calculated_host_listings_count_entire_homes and should be ignored for analysis

Correlation0.9820095924

host_response_rate
Numeric

Distinct count79
Unique (%)0.1%
Missing (%)29.3%
Missing (n)24307
Infinite (%)0.0%
Infinite (n)0
Mean93.13234743
Minimum0
Maximum100
Zeros (%)1.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile60
Q196
Median100
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range4

Descriptive statistics

Standard deviation17.37685787
Coef of variation0.1865824104
Kurtosis15.30808278
Mean93.13234743
MAD9.952461339
Skewness-3.762046953
Sum5466310
Variance301.9551893
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
100 39036 47.0%
 
90 2140 2.6%
 
96 1829 2.2%
 
80 1385 1.7%
 
99 1371 1.7%
 
0 1097 1.3%
 
97 1080 1.3%
 
98 1039 1.3%
 
50 752 0.9%
 
89 679 0.8%
 
Other values (68) 8286 10.0%
 
(Missing) 24307 29.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1097 1.3%
 
7 1 < 0.1%
 
9 7 < 0.1%
 
10 13 < 0.1%
 
11 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
100 39036 47.0%
 
99 1371 1.7%
 
98 1039 1.3%
 
97 1080 1.3%
 
96 1829 2.2%
 

host_total_listings_count
Highly correlated

This variable is highly correlated with host_listings_count and should be ignored for analysis

Correlation1

latitude
Numeric

Distinct count20464
Unique (%)24.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean51.50948047
Minimum51.29272
Maximum51.68657
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum51.29272
5-th percentile51.42477
Q151.4853
Median51.51395
Q351.53731
95-th percentile51.58339
Maximum51.68657
Range0.39385
Interquartile range0.05201

Descriptive statistics

Standard deviation0.04620385519
Coef of variation0.0008969971113
Kurtosis0.9481528856
Mean51.50948047
MAD0.03507655089
Skewness-0.3341730115
Sum4275338.388
Variance0.002134796234
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[51.29272 51.3351 51.34707 51.359925 51.37124 ... 51.64321 51.650355 51.656645 51.674035 51.68657 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
51.51571 23 < 0.1%
 
51.51682 23 < 0.1%
 
51.51516 22 < 0.1%
 
51.52559 21 < 0.1%
 
51.51508 21 < 0.1%
 
51.51264 21 < 0.1%
 
51.4933 21 < 0.1%
 
51.51652 21 < 0.1%
 
51.52486 21 < 0.1%
 
51.49851 20 < 0.1%
 
Other values (20454) 82787 99.7%
 

Minimum 5 values

ValueCountFrequency (%) 
51.29272 1 < 0.1%
 
51.29454 1 < 0.1%
 
51.29479 1 < 0.1%
 
51.29712 1 < 0.1%
 
51.29733 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
51.68657 1 < 0.1%
 
51.68169 1 < 0.1%
 
51.67984 1 < 0.1%
 
51.6792 1 < 0.1%
 
51.67651 1 < 0.1%
 

longitude
Numeric

Distinct count31565
Unique (%)38.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean-0.1283144238
Minimum-0.5013
Maximum0.29657
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-0.5013
5-th percentile-0.28271
Q1-0.18828
Median-0.12576
Q3-0.07036
95-th percentile0.01337
Maximum0.29657
Range0.79787
Interquartile range0.11792

Descriptive statistics

Standard deviation0.09219373613
Coef of variation-0.7184986177
Kurtosis1.192943761
Mean-0.1283144238
MAD0.07088540533
Skewness-0.1363595077
Sum-10650.22549
Variance0.008499684983
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-0.5013 -0.484465 -0.458 -0.448895 -0.382805 ... 0.115845 0.13238 0.19484 0.238175 0.29657 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-0.07057 15 < 0.1%
 
-0.0718 13 < 0.1%
 
-0.09728 13 < 0.1%
 
-0.13472 13 < 0.1%
 
-0.1648 13 < 0.1%
 
-0.07255 12 < 0.1%
 
-0.07448 12 < 0.1%
 
-0.19255 12 < 0.1%
 
-0.07015 12 < 0.1%
 
-0.19517 12 < 0.1%
 
Other values (31555) 82874 99.8%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.5013 1 < 0.1%
 
-0.49918 1 < 0.1%
 
-0.49582 1 < 0.1%
 
-0.49509 1 < 0.1%
 
-0.48786 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
0.29657 1 < 0.1%
 
0.28774 1 < 0.1%
 
0.28539 1 < 0.1%
 
0.28429 1 < 0.1%
 
0.27268 1 < 0.1%
 

neighbourhood_cleansed
Categorical

Distinct count33
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Westminster
 
9333
Tower Hamlets
 
7958
Hackney
 
6040
Other values (30)
59670
ValueCountFrequency (%) 
Westminster 9333 11.2%
 
Tower Hamlets 7958 9.6%
 
Hackney 6040 7.3%
 
Camden 5913 7.1%
 
Kensington and Chelsea 5802 7.0%
 
Islington 5100 6.1%
 
Southwark 4842 5.8%
 
Lambeth 4761 5.7%
 
Wandsworth 4208 5.1%
 
Hammersmith and Fulham 4155 5.0%
 
Other values (23) 24889 30.0%
 
Max length22
Mean length10.61882387
Min length5
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

number_of_reviews
Numeric

Distinct count394
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean16.49200612
Minimum0
Maximum665
Zeros (%)25.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median4
Q317
95-th percentile75
Maximum665
Range665
Interquartile range17

Descriptive statistics

Standard deviation34.92925879
Coef of variation2.117950875
Kurtosis39.26389222
Mean16.49200612
MAD19.33499945
Skewness5.074501643
Sum1368853
Variance1220.05312
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.500e+00 2.500e+00 3.500e+00 ... 2.555e+02 2.850e+02 3.755e+02 5.120e+02 6.650e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 20792 25.1%
 
1 8917 10.7%
 
2 5735 6.9%
 
3 4472 5.4%
 
4 3474 4.2%
 
5 2777 3.3%
 
6 2343 2.8%
 
7 2056 2.5%
 
8 1724 2.1%
 
9 1669 2.0%
 
Other values (384) 29042 35.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 20792 25.1%
 
1 8917 10.7%
 
2 5735 6.9%
 
3 4472 5.4%
 
4 3474 4.2%
 

Maximum 5 values

ValueCountFrequency (%) 
665 1 < 0.1%
 
598 1 < 0.1%
 
589 1 < 0.1%
 
579 1 < 0.1%
 
578 1 < 0.1%
 

number_of_reviews_ltm
Numeric

Distinct count148
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean6.702268647
Minimum0
Maximum200
Zeros (%)40.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q38
95-th percentile31
Maximum200
Range200
Interquartile range8

Descriptive statistics

Standard deviation12.64576431
Coef of variation1.886788635
Kurtosis19.60888575
Mean6.702268647
MAD7.894171309
Skewness3.682787627
Sum556295
Variance159.915355
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 81.5 90.5 107.5 140. 200. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 33561 40.4%
 
1 8087 9.7%
 
2 5455 6.6%
 
3 4214 5.1%
 
4 3374 4.1%
 
5 2670 3.2%
 
6 2347 2.8%
 
7 2067 2.5%
 
8 1763 2.1%
 
9 1616 1.9%
 
Other values (138) 17847 21.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 33561 40.4%
 
1 8087 9.7%
 
2 5455 6.6%
 
3 4214 5.1%
 
4 3374 4.1%
 

Maximum 5 values

ValueCountFrequency (%) 
200 1 < 0.1%
 
191 1 < 0.1%
 
180 1 < 0.1%
 
176 1 < 0.1%
 
165 1 < 0.1%
 

price
Numeric

Distinct count911
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean121.9246515
Minimum0
Maximum13700
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile25
Q145
Median82
Q3140
95-th percentile320
Maximum13700
Range13700
Interquartile range95

Descriptive statistics

Standard deviation225.8462003
Coef of variation1.85234239
Kurtosis1030.278324
Mean121.9246515
MAD82.30763758
Skewness25.10330353
Sum10119868
Variance51006.5062
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000e+00 3.0000e+00 7.5000e+00 8.5000e+00 9.5000e+00 ... 2.9575e+03 3.0600e+03 4.7500e+03 5.1075e+03 1.3700e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
50 3091 3.7%
 
100 2923 3.5%
 
40 2689 3.2%
 
35 2434 2.9%
 
45 2311 2.8%
 
30 2303 2.8%
 
120 2266 2.7%
 
150 2194 2.6%
 
60 2190 2.6%
 
80 2156 2.6%
 
Other values (901) 58444 70.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 19 < 0.1%
 
6 1 < 0.1%
 
7 5 < 0.1%
 
8 27 < 0.1%
 
9 4 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
13700 1 < 0.1%
 
12345 4 < 0.1%
 
10000 2 < 0.1%
 
9999 3 < 0.1%
 
8000 1 < 0.1%
 

property_type
Categorical

Distinct count40
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Apartment
56267
House
17197
Townhouse
 
2943
Other values (37)
 
6594
ValueCountFrequency (%) 
Apartment 56267 67.8%
 
House 17197 20.7%
 
Townhouse 2943 3.5%
 
Serviced apartment 1890 2.3%
 
Condominium 1099 1.3%
 
Bed and breakfast 872 1.1%
 
Loft 711 0.9%
 
Guest suite 355 0.4%
 
Guesthouse 279 0.3%
 
Hostel 227 0.3%
 
Other values (30) 1161 1.4%
 
Max length22
Mean length8.435344152
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

review_scores_accuracy
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)27.1%
Missing (n)22485
Infinite (%)0.0%
Infinite (n)0
Mean9.518408355
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation0.973909779
Coef of variation0.102318554
Kurtosis20.03370452
Mean9.518408355
MAD0.6608555324
Skewness-3.724294125
Sum576016
Variance0.9485002577
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 41521 50.0%
 
9 13595 16.4%
 
8 3466 4.2%
 
7 697 0.8%
 
6 676 0.8%
 
2 277 0.3%
 
4 174 0.2%
 
5 104 0.1%
 
3 6 < 0.1%
 
(Missing) 22485 27.1%
 

Minimum 5 values

ValueCountFrequency (%) 
2 277 0.3%
 
3 6 < 0.1%
 
4 174 0.2%
 
5 104 0.1%
 
6 676 0.8%
 

Maximum 5 values

ValueCountFrequency (%) 
10 41521 50.0%
 
9 13595 16.4%
 
8 3466 4.2%
 
7 697 0.8%
 
6 676 0.8%
 

review_scores_checkin
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)27.2%
Missing (n)22537
Infinite (%)0.0%
Infinite (n)0
Mean9.633103996
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q110
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.8935611894
Coef of variation0.09275942519
Kurtosis27.21963505
Mean9.633103996
MAD0.5602834026
Skewness-4.407604451
Sum582456
Variance0.7984515992
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 46167 55.6%
 
9 10296 12.4%
 
8 2460 3.0%
 
7 544 0.7%
 
6 541 0.7%
 
2 251 0.3%
 
4 129 0.2%
 
5 71 0.1%
 
3 5 < 0.1%
 
(Missing) 22537 27.2%
 

Minimum 5 values

ValueCountFrequency (%) 
2 251 0.3%
 
3 5 < 0.1%
 
4 129 0.2%
 
5 71 0.1%
 
6 541 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
10 46167 55.6%
 
9 10296 12.4%
 
8 2460 3.0%
 
7 544 0.7%
 
6 541 0.7%
 

review_scores_cleanliness
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)27.1%
Missing (n)22474
Infinite (%)0.0%
Infinite (n)0
Mean9.28640111
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile7
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation1.119944107
Coef of variation0.1206004451
Kurtosis11.24120513
Mean9.28640111
MAD0.8012321864
Skewness-2.749221146
Sum562078
Variance1.254274803
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 33980 40.9%
 
9 17024 20.5%
 
8 6217 7.5%
 
7 1510 1.8%
 
6 1010 1.2%
 
2 307 0.4%
 
4 283 0.3%
 
5 181 0.2%
 
3 15 < 0.1%
 
(Missing) 22474 27.1%
 

Minimum 5 values

ValueCountFrequency (%) 
2 307 0.4%
 
3 15 < 0.1%
 
4 283 0.3%
 
5 181 0.2%
 
6 1010 1.2%
 

Maximum 5 values

ValueCountFrequency (%) 
10 33980 40.9%
 
9 17024 20.5%
 
8 6217 7.5%
 
7 1510 1.8%
 
6 1010 1.2%
 

review_scores_communication
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)27.1%
Missing (n)22482
Infinite (%)0.0%
Infinite (n)0
Mean9.664353344
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q110
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.8795104364
Coef of variation0.09100561674
Kurtosis29.34634106
Mean9.664353344
MAD0.5297004389
Skewness-4.632967078
Sum584877
Variance0.7735386078
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 47754 57.5%
 
9 9035 10.9%
 
8 2231 2.7%
 
7 527 0.6%
 
6 516 0.6%
 
2 243 0.3%
 
4 148 0.2%
 
5 58 0.1%
 
3 7 < 0.1%
 
(Missing) 22482 27.1%
 

Minimum 5 values

ValueCountFrequency (%) 
2 243 0.3%
 
3 7 < 0.1%
 
4 148 0.2%
 
5 58 0.1%
 
6 516 0.6%
 

Maximum 5 values

ValueCountFrequency (%) 
10 47754 57.5%
 
9 9035 10.9%
 
8 2231 2.7%
 
7 527 0.6%
 
6 516 0.6%
 

review_scores_location
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)27.2%
Missing (n)22536
Infinite (%)0.0%
Infinite (n)0
Mean9.524981394
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation0.8267743115
Coef of variation0.08680062221
Kurtosis19.58672382
Mean9.524981394
MAD0.614660642
Skewness-3.324764529
Sum575928
Variance0.6835557622
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 39120 47.1%
 
9 16601 20.0%
 
8 3595 4.3%
 
6 484 0.6%
 
7 409 0.5%
 
2 133 0.2%
 
4 87 0.1%
 
5 35 < 0.1%
 
3 1 < 0.1%
 
(Missing) 22536 27.2%
 

Minimum 5 values

ValueCountFrequency (%) 
2 133 0.2%
 
3 1 < 0.1%
 
4 87 0.1%
 
5 35 < 0.1%
 
6 484 0.6%
 

Maximum 5 values

ValueCountFrequency (%) 
10 39120 47.1%
 
9 16601 20.0%
 
8 3595 4.3%
 
7 409 0.5%
 
6 484 0.6%
 

review_scores_rating
Numeric

Distinct count59
Unique (%)0.1%
Missing (%)27.0%
Missing (n)22434
Infinite (%)0.0%
Infinite (n)0
Mean92.74043621
Minimum20
Maximum100
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20
5-th percentile78
Q190
Median96
Q3100
95-th percentile100
Maximum100
Range80
Interquartile range10

Descriptive statistics

Standard deviation9.957765382
Coef of variation0.1073724234
Kurtosis15.64786751
Mean92.74043621
MAD6.62188899
Skewness-3.187230575
Sum5617010
Variance99.1570914
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
100 17458 21.0%
 
98 3868 4.7%
 
93 3655 4.4%
 
96 3608 4.3%
 
97 3559 4.3%
 
95 3328 4.0%
 
90 3188 3.8%
 
80 3183 3.8%
 
99 2429 2.9%
 
94 2270 2.7%
 
Other values (48) 14021 16.9%
 
(Missing) 22434 27.0%
 

Minimum 5 values

ValueCountFrequency (%) 
20 271 0.3%
 
30 7 < 0.1%
 
33 1 < 0.1%
 
35 1 < 0.1%
 
40 196 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
100 17458 21.0%
 
99 2429 2.9%
 
98 3868 4.7%
 
97 3559 4.3%
 
96 3608 4.3%
 

review_scores_value
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)27.2%
Missing (n)22535
Infinite (%)0.0%
Infinite (n)0
Mean9.283332782
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation1.025273471
Coef of variation0.1104423912
Kurtosis14.0169692
Mean9.283332782
MAD0.7254616987
Skewness-2.92321941
Sum561326
Variance1.051185691
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 30604 36.9%
 
9 21903 26.4%
 
8 5555 6.7%
 
7 955 1.2%
 
6 840 1.0%
 
2 275 0.3%
 
4 204 0.2%
 
5 119 0.1%
 
3 11 < 0.1%
 
(Missing) 22535 27.2%
 

Minimum 5 values

ValueCountFrequency (%) 
2 275 0.3%
 
3 11 < 0.1%
 
4 204 0.2%
 
5 119 0.1%
 
6 840 1.0%
 

Maximum 5 values

ValueCountFrequency (%) 
10 30604 36.9%
 
9 21903 26.4%
 
8 5555 6.7%
 
7 955 1.2%
 
6 840 1.0%
 

reviews_per_month
Numeric

Distinct count939
Unique (%)1.1%
Missing (%)25.0%
Missing (n)20791
Infinite (%)0.0%
Infinite (n)0
Mean1.214102556
Minimum0
Maximum30.93
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.05
Q10.25
Median0.75
Q31.65
95-th percentile4.07
Maximum30.93
Range30.93
Interquartile range1.4

Descriptive statistics

Standard deviation1.419411363
Coef of variation1.169103348
Kurtosis10.78112772
Mean1.214102556
MAD1.004085061
Skewness2.471008393
Sum75529.32
Variance2.014728617
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 2032 2.4%
 
0.08 1000 1.2%
 
0.16 955 1.2%
 
0.04 942 1.1%
 
0.05 932 1.1%
 
0.09 897 1.1%
 
0.03 861 1.0%
 
2 808 1.0%
 
0.02 804 1.0%
 
0.06 784 0.9%
 
Other values (928) 52195 62.9%
 
(Missing) 20791 25.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
0.01 37 < 0.1%
 
0.02 804 1.0%
 
0.03 861 1.0%
 
0.04 942 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
30.93 1 < 0.1%
 
17.03 1 < 0.1%
 
15 1 < 0.1%
 
14.64 2 < 0.1%
 
14.63 1 < 0.1%
 

room_type
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Entire home/apt
46694
Private room
35582
Shared room
 
725
ValueCountFrequency (%) 
Entire home/apt 46694 56.3%
 
Private room 35582 42.9%
 
Shared room 725 0.9%
 
Max length15
Mean length13.67897977
Min length11
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

security_deposit
Numeric

Distinct count382
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean130.8046289
Minimum0
Maximum17995
Zeros (%)57.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q3200
95-th percentile500
Maximum17995
Range17995
Interquartile range200

Descriptive statistics

Standard deviation282.6378046
Coef of variation2.160763018
Kurtosis244.9812768
Mean130.8046289
MAD160.1246022
Skewness8.606064364
Sum10856915
Variance79884.12858
Memory size648.6 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 28. 58.5 64.5 65.5 ... 3511. 3737. 3951.5 4069. 17995. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 47852 57.7%
 
100 5796 7.0%
 
200 4925 5.9%
 
250 3476 4.2%
 
300 3232 3.9%
 
500 3177 3.8%
 
150 2844 3.4%
 
85 1831 2.2%
 
495 1289 1.6%
 
1000 1073 1.3%
 
Other values (372) 7506 9.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 47852 57.7%
 
56 1 < 0.1%
 
57 1 < 0.1%
 
60 18 < 0.1%
 
61 6 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
17995 1 < 0.1%
 
4098 1 < 0.1%
 
4040 1 < 0.1%
 
4003 1 < 0.1%
 
4000 2 < 0.1%
 

zipcode
Categorical

Distinct count33819
Unique (%)40.7%
Missing (%)2.3%
Missing (n)1947
E1
 
451
SE1
 
400
NW1
 
366
Other values (33815)
79837
(Missing)
 
1947
ValueCountFrequency (%) 
E1 451 0.5%
 
SE1 400 0.5%
 
NW1 366 0.4%
 
N1 349 0.4%
 
E2 329 0.4%
 
W2 304 0.4%
 
E14 263 0.3%
 
SW6 199 0.2%
 
SW11 175 0.2%
 
E3 153 0.2%
 
Other values (33808) 78065 94.1%
 
(Missing) 1947 2.3%
 
Max length22
Mean length6.360031807
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Correlations

Missing values

Sample

First rows

accommodatesamenitiesbathroomsbed_typebedroomsbedscalculated_host_listings_countcalculated_host_listings_count_entire_homescalculated_host_listings_count_private_roomscalculated_host_listings_count_shared_roomscleaning_feedf_indexexperiences_offeredextra_peopleguests_includedhost_idhost_listings_counthost_response_ratehost_total_listings_countlatitudelongitudeneighbourhood_cleansednumber_of_reviewsnumber_of_reviews_ltmpriceproperty_typereview_scores_accuracyreview_scores_checkinreview_scores_cleanlinessreview_scores_communicationreview_scores_locationreview_scores_ratingreview_scores_valuereviews_per_monthroom_typesecurity_depositzipcode
02{TV,"Cable TV",Wifi,Kitchen,"Paid parking off premises","Smoking allowed","Free street parking","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"Children’s books and toys","Babysitter recommendations",Crib,"Pack ’n Play/travel crib","Room-darkening shades","Children’s dinnerware","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection","Coffee maker",Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Patio or balcony","Luggage dropoff allowed","Long term stays allowed","No stairs or steps to enter","Wide entrance","Extra space around bed","Accessible-height bed","No stairs or steps to enter","Wide doorway to guest bathroom","Bathtub with bath chair","Accessible-height toilet","Host greets you","Handheld shower head","Roll-in shower"}1.0Real Bed1.00.0312015.00business15.01547304.086.04.051.56802-0.11121Islington16265.0Apartment9.09.010.010.09.096.09.00.15Private room100.0N4 3
12{TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water","Luggage dropoff allowed","Long term stays allowed",Other}1.0Real Bed1.01.0110050.01romantic0.02603021.0100.01.051.48796-0.16898Kensington and Chelsea854100.0Apartment10.010.010.010.010.096.09.00.73Entire home/apt150.0SW3
26{TV,Wifi,Kitchen,"Paid parking off premises",Elevator,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Hot water","Bed linens",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed"}2.0Real Bed3.03.014140065.02none10.046756419.085.019.051.52098-0.14002Westminster4112300.0Apartment10.09.09.09.010.094.09.00.41Entire home/apt350.0W1T4BP
32{TV,"Cable TV",Internet,Wifi,Kitchen,"Free parking on premises","Pets allowed","Pets live on this property","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Hot water","Long term stays allowed"}1.5Real Bed1.01.0110070.03family0.02417592.0100.02.051.47298-0.16376Wandsworth931175.0Townhouse10.010.010.010.09.098.09.00.88Entire home/apt250.0SW11 5GX
44{TV,Wifi,Kitchen,"Free parking on premises",Elevator,"Buzzer/wireless intercom",Heating,Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water","Host greets you"}1.0Real Bed2.02.0110050.04none11.021028131.0100.01.051.44687-0.21874Wandsworth28365.0Apartment10.09.09.09.09.091.09.00.69Entire home/apt250.0SW19 6QH
52{Wifi,Kitchen,"Buzzer/wireless intercom",Heating,Washer,"Smoke detector",Essentials,Shampoo,"Lock on bedroom door","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}1.5Real Bed1.01.030300.05none8.011035833.070.03.051.57224-0.20906Barnet122829.0House10.010.010.010.09.095.010.01.08Private room100.0NW11 9
64{TV,"Cable TV",Internet,Wifi,Kitchen,"Paid parking off premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"High chair","Children’s books and toys",Crib,"Pack ’n Play/travel crib","Children’s dinnerware","Hot water","Bed linens","Extra pillows and blankets","Luggage dropoff allowed","Long term stays allowed","Host greets you"}1.0Real Bed1.03.0550075.06none15.031108655.0100.05.051.54168-0.10207Islington6210147.0Apartment8.09.09.09.09.085.08.00.59Entire home/apt100.0N1 2
75{TV,"Cable TV",Internet,Wifi,Kitchen,"Paid parking off premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"High chair","Children’s books and toys",Crib,"Pack ’n Play/travel crib","Game console","Hot water","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Luggage dropoff allowed","Long term stays allowed","Host greets you"}1.0Real Bed1.01.0550075.07none10.031108655.0100.05.051.53883-0.10153Islington7912147.0Apartment9.09.09.010.010.090.09.00.75Entire home/apt100.0N1 2
82{TV,Wifi,Kitchen,"Paid parking off premises",Breakfast,Heating,Washer,"Smoke detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"translation missing: en.hosting_amenity_50","Hot water",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Garden or backyard","Host greets you"}1.5Real Bed1.01.0101010.08none12.011346062.0100.02.051.534840.02707Newham1151134.0Townhouse10.010.010.010.09.097.010.01.05Private room0.0E13 0QF
92{Wifi,Kitchen,"Pets live on this property",Cat(s),"Free street parking",Heating,Washer,Dryer,"Smoke detector",Essentials,"Self check-in","Building staff","Hot water"}1.0Real Bed1.01.010100.09none0.011444441.0100.01.051.46507-0.32421Hounslow53100.0House9.010.010.010.010.088.08.00.05Private room0.0TW7 7HG

Last rows

accommodatesamenitiesbathroomsbed_typebedroomsbedscalculated_host_listings_countcalculated_host_listings_count_entire_homescalculated_host_listings_count_private_roomscalculated_host_listings_count_shared_roomscleaning_feedf_indexexperiences_offeredextra_peopleguests_includedhost_idhost_listings_counthost_response_ratehost_total_listings_countlatitudelongitudeneighbourhood_cleansednumber_of_reviewsnumber_of_reviews_ltmpriceproperty_typereview_scores_accuracyreview_scores_checkinreview_scores_cleanlinessreview_scores_communicationreview_scores_locationreview_scores_ratingreview_scores_valuereviews_per_monthroom_typesecurity_depositzipcode
829914{TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Pets allowed",Elevator,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Private entrance","High chair","Pack ’n Play/travel crib","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Patio or balcony","Luggage dropoff allowed","Long term stays allowed","Wide hallways",Waterfront}2.0Real Bed2.03.02200100.083840none0.012145593751.060.01.051.48173-0.17813Kensington and Chelsea00400.0ApartmentNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt0.0SW10
829928{TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Elevator,Heating,"Suitable for events",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron}3.0Real Bed4.04.011000.083841none0.012749790660.0NaN0.051.49769-0.17984Kensington and Chelsea00500.0CondominiumNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt0.0SW7 5QQ
829934{TV,Internet,Wifi,Kitchen,"Pets allowed",Gym,Elevator,"Free street parking",Heating,Washer,Dryer,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in","Smart lock","Private entrance","Hot water","Luggage dropoff allowed","Long term stays allowed"}1.0Real Bed2.02.0110030.083842none20.02987805153.0100.03.051.48060-0.03378Lewisham00100.0ApartmentNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt300.0SE14 6BY
829944{Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}1.0Real Bed2.02.022000.083843none0.0199616402.0100.02.051.53911-0.13478Camden00160.0TownhouseNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt0.0NW1 0BQ
829951{Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,Iron,"Hot water","Bed linens","Extra pillows and blankets","Garden or backyard"}1.5Real Bed1.01.0606020.083844none5.01848472517.079.017.051.55124-0.04877Hackney0020.0HouseNaNNaNNaNNaNNaNNaNNaNNaNPrivate room80.0E5 0LQ
829964{Wifi,Kitchen,"Free parking on premises",Heating,"Smoke detector",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance"}1.0Real Bed2.02.0110050.083845none40.01907706811.067.01.051.53057-0.18423Westminster00100.0LoftNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt0.0NW8 9YB
829971{TV,Wifi,Kitchen,Heating,"Smoke detector",Essentials,Iron,"Laptop friendly workspace"}1.0Real Bed1.01.01818000.083846none0.014760903617.0100.017.051.52301-0.08979Islington0082.0ApartmentNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt0.0EC1Y 8TQ
829981{TV,Wifi,Kitchen,Heating,"Smoke detector",Essentials,Iron,"Laptop friendly workspace"}1.0Real Bed1.01.01818000.083847none0.014760903617.0100.017.051.52301-0.08979Islington0078.0ApartmentNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt0.0EC1Y 8TQ
829992{TV,Wifi,Kitchen,Heating,"Smoke detector",Essentials,Iron,"Laptop friendly workspace"}1.0Real Bed1.01.01818000.083848none0.014760903617.0100.017.051.52301-0.08979Islington0082.0ApartmentNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt0.0EC1Y 8TQ
830002{Wifi,Kitchen,Essentials,"Hair dryer",Iron}1.0Real Bed1.01.01818000.083849none0.014760903617.0100.017.051.51050-0.01788Tower Hamlets0072.0ApartmentNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt0.0E14